<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-family:'MS Shell Dlg 2'; font-size:10pt; font-weight:400; font-style:normal;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'Courier New'; font-weight:600; color:#004080; background-color:#eeeeee;">let</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'Courier New'; color:#000000;">    list  </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">=</span><span style=" font-family:'Courier New'; color:#000000;"> </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080c0;">List.Buffer</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">(</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080c0;">Excel.CurrentWorkbook</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">(){[</span><span style=" font-family:'Courier New'; color:#000000;">Name</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">=</span><span style=" font-family:'Courier New'; color:#800000;">&quot;Таблица2&quot;</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">]}[</span><span style=" font-family:'Courier New'; color:#000000;">Content</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">][</span><span style=" font-family:'Courier New'; color:#000000;">Фильтр</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">]),</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'Courier New'; color:#000000;">    from </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">=</span><span style=" font-family:'Courier New'; color:#000000;"> </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080c0;">Excel.CurrentWorkbook</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">(){[</span><span style=" font-family:'Courier New'; color:#000000;">Name</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">=</span><span style=" font-family:'Courier New'; color:#800000;">&quot;Таблица1&quot;</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">]}[</span><span style=" font-family:'Courier New'; color:#000000;">Content</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">],</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'Courier New'; color:#000000;">    to </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">=</span><span style=" font-family:'Courier New'; color:#000000;"> </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080c0;">Table.SelectRows</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">(</span><span style=" font-family:'Courier New'; color:#000000;">from</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">,</span><span style=" font-family:'Courier New'; color:#000000;"> </span><span style=" font-family:'Courier New'; font-weight:600; color:#ff8000;">each</span><span style=" font-family:'Courier New'; color:#000000;"> </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080c0;">List.Contains</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">(</span><span style=" font-family:'Courier New'; color:#000000;">list</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">,[</span><span style=" font-family:'Courier New'; color:#000000;">Наименование</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">]))</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'Courier New'; font-weight:600; color:#004080; background-color:#eeeeee;">in</span></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'Courier New'; color:#000000;">    to</span></p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; font-family:'Courier New'; color:#000000;"><br /></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'Courier New'; color:#000000;">#</span><span style=" font-family:'Courier New'; color:#800000;">&quot;Фильтр по списку Ref&quot;</span><span style=" font-family:'Courier New'; color:#000000;"> </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">=</span><span style=" font-family:'Courier New'; color:#000000;"> </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080c0;">Table.SelectRows</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">(</span><span style=" font-family:'Courier New'; color:#000000;"> Источник </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">,</span><span style=" font-family:'Courier New'; color:#000000;"> </span><span style=" font-family:'Courier New'; font-weight:600; color:#ff8000;">each</span><span style=" font-family:'Courier New'; color:#000000;"> </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080c0;">List.Contains</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">(</span><span style=" font-family:'Courier New'; color:#000000;"> Список_Ref </span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">,[</span><span style=" font-family:'Courier New'; color:#000000;">Ref</span><span style=" font-family:'Courier New'; font-weight:600; color:#0080ff;">]))</span></p></body></html>